sql> SELECT * FROM observatory WHERE ('2000-10-20T20:30:56'>=time_start AND '2009-10-20T20:30:56'<=time_end) and loc_gen='GBO' ORDER BY time_start LIMIT 50 +------+---------+---------+--------+-------------+-----------------------+-----------------------+--------+------------------------------------------+--------+ | name | loc_gen | loc_p1 | loc_p2 | time_embark | time_start | time_end | status | longname | sat_id | +------+---------+---------+--------+-------------+-----------------------+-----------------------+--------+------------------------------------------+--------+ | MITK | GBO | -139.60 | 36.10 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Mitaka Observatory, Japan | | | KISF | GBO | 16.51 | 28.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Kiepenheuer Institute of Sol. Phys., ... | | | THEM | GBO | 16.51 | 28.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Themis, Tenerife | | | TEID | GBO | 16.51 | 28.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Obs. del Teide, Tenerife | | | CUCS | GBO | 69.33 | -31.80 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | OAFA - CU. Cesco Station, Argentina | | | CTIO | GBO | 70.81 | -30.17 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Cerro Tololo Interamerican Obs., Chile | | | KBOU | GBO | 105.20 | 40.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Space Env. Lab., Boulder CO USA | | | KSAC | GBO | 105.80 | 32.80 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | NSO at Sac Peak, NM USA | | | KHMN | GBO | 106.00 | 33.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Holloman Air Force Base, NM USA | | | TUCS | GBO | 111.00 | 32.25 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | NSO at Tucson, AZ USA | | | KPNO | GBO | 111.60 | 32.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | NSO at Kitt Peak, AZ USA | | | BBSO | GBO | 117.00 | 34.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Big Bear Solar Observatory, CA USA | | | OVRO | GBO | 117.90 | 36.40 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Owens Valley Radio Observatory, CA USA | | | MWSO | GBO | 118.10 | 34.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Mt. Wilson Solar Observatory, CA USA | | | MEES | GBO | 155.40 | 19.60 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Mees Observatory, Hawaii | | | OAUC | GBO | 8.50 | 40.20 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | ObservatoÌýrio AstronoÌýmico da Unive... | | | PDMO | GBO | -0.10 | 43.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Pic du Midi Observatory, France | | | NOBE | GBO | -138.20 | 36.40 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Nobeyama Radioheliograph, Japan | | | HIDA | GBO | -137.40 | 36.30 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Hida Obs., Univ Kyoto, Japan | | | HSOS | GBO | -116.60 | 40.40 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Huairou Solar Observatory, China | | | LEAR | GBO | -114.60 | -22.12 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Learmonth Solar Observatory, Australia | | | YNAO | GBO | -102.80 | 25.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Yunnan Astronomical Observatory, China | | | UDPR | GBO | -73.71 | 24.59 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Udaipur Solar Observatory, India | | | OSTO | GBO | -69.29 | 41.33 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Observing Station at Tashkent Obs., U... | | | OACT | GBO | -15.10 | 35.50 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Catania Astrophysical Observatory, Italy | | | KANZ | GBO | -14.90 | 46.70 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Kanzelhoehe Solar Observatory, Austria | | | ONDR | GBO | -14.80 | 49.90 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Ondrejov Observatory, Czech Rep. | | | HTPR | GBO | -6.00 | 44.00 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Haute-Provence Obs., France | | | MEUD | GBO | -2.30 | 48.80 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Obs. Paris at Meudon, France | | | NANC | GBO | -2.20 | 47.40 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Nancay Radioheliograph, France | | | MLSO | GBO | 156.60 | 19.50 | | 1980-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | HAO at Mauna Loa Solar Obs., Hawaii | | | KSFO | GBO | 118.50 | 34.30 | | 1985-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | San Fernando Observatory, CA USA | | | BLEN | GBO | -8.70 | 47.40 | | 1998-01-01 00:00:00.0 | 2030-01-01 00:00:00.0 | O | Bleien, Switzerland (ETHZ) | | +------+---------+---------+--------+-------------+-----------------------+-----------------------+--------+------------------------------------------+--------+ Elapsed time: 0.638 sec